﻿CREATE TABLE [inventory].[InventoryItem] (
    [InventoryItemID] INT           IDENTITY (1, 1) NOT NULL,
    [Value]           VARCHAR (50)  NULL,
    [InventoryLot]    VARCHAR (50)  NULL,
    [Location]        VARCHAR (50)  NULL,
    [Description]     VARCHAR (500) NULL,
    [CreatedBy]       VARCHAR (50)  NULL,
    [CreatedDate]     DATETIME      NULL,
    [UpdatedBy]       VARCHAR (50)  NULL,
    [UpdatedDate]     DATETIME      NULL,
    [EndDate]         DATETIME      NULL,
    CONSTRAINT [PK_InventoryItem] PRIMARY KEY CLUSTERED ([InventoryItemID] ASC)
);

